package com.report.reportserver.mapper;

import com.report.reportserver.model.Teacher;
import org.apache.ibatis.annotations.Select;
import java.util.*;

public interface TeacherMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Teacher record);

    int insertSelective(Teacher record);

    Teacher selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Teacher record);

    int updateByPrimaryKey(Teacher record);

    @Select("select * from r_teacher where employer = #{academy}")
    List<Teacher> selectByAcademy(String academy);

    @Select("select * from r_teacher where title = #{title}")
    List<Teacher> selectByTitle(String title);

    @Select("select * from r_teacher where name = #{name}")
    List<Teacher> selectByName(String name);

    @Select("select * from r_teacher where number = #{number}")
    Teacher selectByNumber(String number);
}